
{extend name='public/base' /}

{block name="content"}

<div class="layui-col-md12">
    <div class="layui-card">
        <div class="layui-card-body">
            <form action="" class="layui-form" method="get">
                <div class="layui-form-item layui-form-pane">
                    <div class="layui-inline">
                        <label class="layui-form-label">商户：</label>
                        <div class="layui-input-inline">
                            <select name="merchant_id"  lay-search="" id="merchant_id">
                                <option value="" ></option>
                                {volist name="merchant_list" id="t"}
                                {if empty($t.name)||$t.name=='-'}
                                <option value="{$t.id}" >{$t.company} - {$t.code}-{$t.biz_state}-{$t.positions_code}</option>
                                {else/}
                                <option value="{$t.id}" >{$t.name} - {$t.code}-{$t.biz_state}-{$t.positions_code}</option>
                                {/if}
                                {/volist}
                            </select>
                        </div>
                    </div>
                    <div class="layui-inline">
                        <label class="layui-form-label" style="overflow: inherit;">合同编号：</label>
                        <div class="layui-input-inline">
                            <input name="code" class="layui-input" id="code" value="" type="text"
                                   placeholder="合同编号">
                        </div>
                    </div>
                    <div class="layui-inline">
                        <label class="layui-form-label" style="overflow: inherit;">表编号：</label>
                        <div class="layui-input-inline">
                            <input name="pointId" class="layui-input" id="pointId" value="" type="text"
                                   placeholder="表编号">
                        </div>
                    </div>
                    <div class="layui-inline">
                        <label class="layui-form-label">请选择日期</label>
                        <div class="layui-inline" id="test6">
                            <div class="layui-input-inline">
                                <input type="text" autocomplete="off" name="startDate" id="startDate" class="layui-input" placeholder="开始日期">
                            </div>
<!--                            <div class="layui-form-mid">-</div>-->
<!--                            <div class="layui-input-inline">-->
<!--                                <input type="text" autocomplete="off"  name="endDate" id="endDate" class="layui-input" placeholder="结束日期">-->
<!--                            </div>-->
                        </div>
                    </div>
                    <div class="layui-inline">
                        <button class="layui-btn icon-btn layui-btn-sm" data-id="table_id" lay-filter="search" lay-submit="">
                            <i class="layui-icon"></i>搜索
                        </button>
                        <button type="reset" class="layui-btn icon-btn layui-btn-normal layui-btn-sm"><i class="layui-icon layui-icon-refresh"></i>{:__('Reset')}</button>
                        <button class="layui-btn layui-bg-black iconfont icon-daochu layui-btn-sm" lay-submit id="export" >导出</button>
                    </div>
                </div>
            </form>
        </div>
    </div>
    <div class="layui-card">
        <div class="layui-card-body">
            <table class="layui-hide" id="table_id" lay-filter="table_id"></table>
        </div>
    </div>

</div>
{/block}

{block name="js"} <!--js处理区-->


<script type="text/html" id="toolbarDemo">
    <div class="layui-btn-container">
        <button type="button" lay-event="reload"  class="layui-btn  layui-btn-sm  layui-btn-primary">刷新表格</button>
    </div>
</script>

<script type="text/html" id="operationTpl">
    <a href="javascript:;" class="layui-btn layui-btn-danger layui-btn-xs {:node('MonthElectricityDegree/del')}" data-title="删除"
       lay-event="del"><i class="layui-icon "></i></a>
</script>

<script>
    layui.use(['element', 'table', 'form', 'jquery', 'lucky','opTable','laydate'], function () {
        var element = layui.element;
        var form = layui.form;
        var table = layui.table;
        var $ = layui.jquery;
        var lucky=layui.lucky;
        var opTable = layui.opTable;
        var laydate = layui.laydate;
        form.render();
        laydate.render({
            elem: '#startDate'
            ,type: 'month',
            trigger: 'click'
        });
        // laydate.render({
        //     elem: '#endDate'
        //     ,type: 'month',
        //     trigger: 'click'
        // });
        //导出事件
        $('#export').on('click',function () {
            var merchant_id = $('#merchant_id').val() ;
            var code = $('#code').val() ;
            var pointId = $('#pointId').val() ;
            var startDate = $('#startDate').val() ;
            var url = "{:url('export')}"+'?startDate='+startDate+ "&pointId=" + pointId + "&export=" + 1+ "&merchant_id=" + merchant_id+ "&code=" + code;
            window.open(url);
        });

        //导出时阻止页面刷新
        $(".layui-form").submit(function (e) {
            e.preventDefault();
        })
        var myTables = table.render({
            elem: '#table_id',
            url:"{:url('index')}",
            where: { info_type: 2},
            toolbar: '#toolbarDemo', //开启头部工具栏，并为其绑定左侧模板
            defaultToolbar: ['filter', 'exports', 'print'],
            even: true, //开启隔行背景
            id:'table_id',
            page: { //支持传入 laypage 组件的所有参数（某些参数除外，如：jump/elem） - 详见文档
                layout: ['limit', 'count', 'prev', 'page', 'next', 'skip','last'] //自定义分页布局
                ,groups: 5 //只显示 1 个连续页码
                ,first: false //不显示首页
                ,last: false //不显示尾页
                ,limit:20
                ,limits:[10,20,30,50]
            },
            // height: 'full-100',100',
            text: {
                none: '暂无相关数据'
            },
            cols: [[
                { title: '', type: 'checkbox', fixed: true},
                { title: 'ID', field: 'id'},
                { title: '商户名', field: 'merchant_sn',templet:function (item) {
                    if(item.name=='-'){
                        return item.company
                    }else {
                        return item.name
                    }

                }},
                { title: '合同号', field: 'merchant_sn',templet:function (item) {
                        return item.code
                    }},
                { title: '组织', field: 'organization',templet:function (item) {
                        return item.organization
                    }},
                { title: '业态', field: 'activities',templet:function (item) {
                    if(item.activities=='null'){
                        return ''
                    }else {
                        return item.activities
                    }
                    }},
                { title: '使用类型', field: 'use_type',templet:function (item) {
                        if(item.use_type==1){
                            return '写字楼自用';
                        }else if(item.use_type==2){
                            return '写字楼公区'
                        }else if(item.use_type==3){
                            return '写字楼商户'
                        }else if(item.use_type==4){
                            return '商场自用'
                        }else if(item.use_type==5){
                            return '商场公区'
                        }else if(item.use_type==6){
                            return '商场商户'
                        }else {
                            return '暂无配置'
                        }}},
                // { title: '商户ID', field: 'userId'},
                { title: '表编号', field: 'pointId'},
                { title: '峰开始值', field: 'fengStart'},
                { title: '峰结束值', field: 'fengEnd'},
                { title: '峰电量', field: 'fengEnd',templet:function (item){
                    if(item.fengEnd!='0.00'){
                        return ((item.fengEnd-item.fengStart)*item.rate).toFixed(2);
                    }else{
                        return item.fengPower;
                    }

                    }},
                // { title: '峰单价', field: 'fMoney'},
                { title: '谷开始值', field: 'guStart'},
                { title: '谷结束值', field: 'guEnd'},
                { title: '谷电量', field: 'fengEnd',templet:function (item){
                        if(item.guEnd!='0.00'){
                            return ((item.guEnd-item.guStart)*item.rate).toFixed(2);
                        }else{
                            return item.guPower;
                        }
                    }},
                // { title: '谷单价', field: 'gMoney'},
                { title: '平开始值', field: 'pingStart'},
                { title: '平结束值', field: 'pingEnd'},
                { title: '平电量', field: 'fengEnd',templet:function (item){
                        if(item.pingEnd!='0.00'){
                            return ((item.pingEnd-item.pingStart)*item.rate).toFixed(2);
                        }else{
                            return item.pingPower;
                        }




                    }},
                // { title: '平单价', field: 'pMoney'},
                { title: '倍率', field: 'rate'},
                { title: '月份', field: 'dataTime'},
                { title: '创建时间', field: 'create_time',templet:function (item){
                        if(item.create_time==''||item.create_time==null){
                            return  '暂无';
                        }else {
                            return   layui.util.toDateString((item.create_time)*1000)
                        }
                    }},
                { title: '是否核算', field: 'status',templet:function (item){
                        if(item.status==0){
                            return  '未结算';
                        }else {
                            return '已结算'
                        }
                    }},
                { title: '核算时间', field: 'update_time',templet:function (item){
                        if(item.update_time==''||item.update_time==null){
                            return  '暂无';
                        }else {
                            return   layui.util.toDateString((item.update_time)*1000)
                        }

                    }},
                {templet: '#operationTpl', width:50,fixed:'right', align: 'center', title: '操作'}
            ]],
            //  展开的列配置
            openCols: [
                {field: 'desc', title: '描述信息'}
            ],
            done: function (res) {
                layer.closeAll('loading');
            }
        });


        /**
         * 监听单行工具操作
         */
        table.on('tool(table_id)', function (obj) {
            var data = obj.data;
            var _id=parseInt(data.id);
            var layEvent = obj.event;
            if(layEvent==="detail"){
                lucky.CreateOpenForm("查看","{:url('detail')}?merchant_id=" + data.merchant_id+"&type="+data.electrity_type+"&settlement_time="+data.settlement_time+'&merchant_sn='+data.merchant.merchant_sn);
                return false;
            }else if(layEvent==="del"){
                lucky.FormatData(_id,"{:url('del')}");
            }else if(layEvent==="edit"){
                lucky.CreateOpenForm("审核提交","{:url('common/costEdit')}?id=" + _id);
                return false;
            }else if(layEvent==="print"){
                lucky.CreateOpenForm("打印","{:url('common/costPrint')}?id=" + _id,'85%');
                return false;
            }else if(layEvent==="invoice"){
                var datas = {} ;
                datas.id      = _id ;   //  购买数量
                $.ajax({
                    url:"{:url('invoice')}",
                    type:"post",
                    data: datas,
                    dataType:"json",
                    success:function(data){
                        layer.msg(data.msg,{icon:15,time:1000,shade:0.3});
                        window.location.reload();
                    }
                });
                return false;
            }
        });
        table.on('toolbar(table_id)', function(obj){
            var checkStatus = table.checkStatus(obj.config.id);
            var data = checkStatus.data;
            if(obj.event==="add"){
                lucky.CreateOpenForm("生成费用单","{:url('add')}");
                return false;
                // adminAdd
            } else if(obj.event==="adminAdd"){
                lucky.CreateOpenForm("添加人工缴费用","{:url('adminAdd')}");
                return false;
            }else if(obj.event==="close"){
                opTables.closeAll();
            }else if(obj.event==="open"){
                opTables.openAll();
            }else if(obj.event==="detail"){
                lucky.CreateOpenForm("订单详情","{:url('detail')}");
                return false;
            }else if(obj.event==="reload"){
                lucky.CreateReload();
            }else if(obj.event==="del"){
                var num=0;
                var id=[];
                for (var i in data) {
                    num++;
                    id.push(data[i].id);
                }
                if (num<1) {
                    layer.msg("请选择一项",{time:1500});return false;
                }
                lucky.FormatData(id,"{:url('del')}");
                return  false;
            }
        });

        /**
         * 关键词搜索树
         */
        form.on('submit(search)', function (obj) {
            lucky.CreateSearch(obj.field);
            return false;
        });
    });

</script >

{/block}
